-
Re: How to disable duration dependencies without impacting aggregation of percentage complete
Hey Gabe. Here's a solution I came up with that will auto-calculate the Total % Completed without a dependency or date columns. Here's a link to a sheet with this data in it. You should be able to se…2 · -
Re: Finding Distinct Values in Two Columns
Hey @PM Assist - I used the following and I got "6" as my answer, so hopefully it can work for you too. For your "helper" column that you currently have named "Column29"…1 · -
Re: Flag should turn red whenever over due day is over 30 days and status is not completed
Hey Abiola, You're so close! You don't need a "-30", you need a positive 30. Also, if you're wanting to add "Cancelled" in there as a status, here's the formula: =IF(Status@row = …1 · -
Re: Any recommendations for third party form builders with advanced date field functionality?
I think there's not many Form services out there that integrate with Smartsheet because, well, Smartsheet also does forms, so that's competition! I did a little searching and it looks like a few Form…1 · -
Re: Row limit on Daily/Weekly Email Summaries
Hey Charity. Correct if I'm wrong, but it sounds like you're wanting the ability to see more rows in this "Summary Email" so you can more easily see the new rows that are added. Is that acc…1 ·